﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_COM_USER_MGT_Init_Password')
	BEGIN
		DROP Procedure usp_UPDMS_COM_USER_MGT_Init_Password
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_COM_USER_MGT_Init_Password
**	Desc : 비밀번호를 초기화한다. - 사용자관리 > 비밀번호 초기화에서 호출
**	Test Exec Query : Exec usp_UPDMS_COM_USER_MGT_Init_Password
**	Called by : Com_Dac_UPDMS_COM_USER_MGT.cs
**	Program ID : Com3016p
**	Auth : 송시명
**	Date : 2013-06-25
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_COM_USER_MGT_Init_Password]
@ls_user_id nvarchar(20),
@ls_pw nvarchar(50),
@ls_update_user nvarchar(20)
AS
SET NOCOUNT OFF

UPDATE UPDMS_COM_USER_MGT
   SET Pw = @ls_pw,
       Pw_Update_Dt = GETDATE(),
       Update_User = @ls_update_user,
       Update_Dt = GETDATE()
 WHERE User_Id = @ls_user_id

GO